package com.example.demo.repository;

import com.example.demo.domain.Express;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface ExpressMapper {

    //查询
    Express getExpressById(Integer id);
    //添加
    void addExpress(Express express);
    //删除
    void delExpressById(Integer id);
    //修改
    void saveExpress(Express express);

    @Select("select id from express where nu=#{nu}")
    Integer getIdByNu(String nu);
}
